CREATE external TABLE jms_ods.customer_complaint_warning_configuration (
  `id` bigint COMMENT '主键id',
  `warning_level` int COMMENT '预警等级 1：高，2：中，3：低',
  `score_begin` decimal(20, 8) COMMENT '预警得分开始',
  `score_end` decimal(20, 8)  COMMENT '预警得分结束',
  `create_work_order` int COMMENT '是否产生工单 1：是，2：否',
  `create_by_code` string COMMENT '创建人code',
  `create_by_name` string COMMENT '创建人名称',
  `create_time` timestamp COMMENT '创建时间',
  `update_by_code` timestamp COMMENT '修改人code',
  `update_time` timestamp COMMENT '修改时间',
  `update_by_name` string COMMENT '修改人名称'
) comment '客诉预警配置表'
PARTITIONED BY (
  `dt` string COMMENT '时间分区')
ROW FORMAT SERDE
  'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
STORED AS INPUTFORMAT
  'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat'
OUTPUTFORMAT
  'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
LOCATION
  '/dw/hive/jms_ods.db/external/customer_complaint_warning_configuration';